Tasks to complete:
Assure you are on a clean worksheet.
Drag both Profit and Sales to the Rows.
Rows
Drag Order Date to the Columns. Assure it is continuous. Drill to the Month level.
Columns
Your visual should match the visual under Dual Axis in the previous text.
From the Sales drop down select Dual Axis
Dual Axis
Quiz 1 below.
Note, you can perform this type of overlap in lots of cases, but it isn't always best.
Nice job!
Select the below that is true regarding the downside of this visualization.
It is hard to tell the difference between the Sales and Profit lines because they overlap.
Having two different vertical axes can be confusing for an audience member.
The dates don't match up.
Next Concept